package com.luoying.itew.db;

import android.provider.BaseColumns;

import com.amap.api.maps.offlinemap.City;

import java.util.stream.BaseStream;

/**
 * 数据库常量
 */
public final class DBConstant {

    //私有化构造函数
    private void DBConstant(){};

    /**
     * 用户表数据
     */
    public static  class UserTable {
        /**
         * 表名
         */
        public static final String TABLE_NAME = "user";
        /**
         * 用户id
         */
        public static final String USER_ID = "userid";
        /**
         * 用户登录名
         */
        public static final String USER_LOGIN_NAME = "user_login_name";

        /**
         * 用户手机号
         */
        public static final String USER_MOBILE = "user_mobile";

        /**
         * 用户名称
         */
        public static final String USER_NAME = "user_name";

        /**
         * 用户管理城市
         */
        public static final String USER_CITY = "user_city";
        /**
         * 用户级别
         */
        public static final String USER_LEVEL = "user_level";
        /**
         * 用户级别
         */
        public static final String USER_TYPE = "user_type";
        /**
         * 用户职位
         */
        public static final String USER_POSITION = "user_position";
    }

    /**
     * 监测点表
     */
    public static class PointTable {
        /**
         * 表名
         */
        public static final String TABLE_NAME = "point_tb";
        /**
         * 点id
         */
        public static final String POINT_ID = "point_id";
        /**
         * 监测点所属街道id
         */
        public static final String POINT_AREA_ID = "point_area_id";
        /**
         * 名称
         */
        public static final String POINT_NAME = "point_name";
        /**
         * 预警开关
         */
        public static final String POINT_STATUS = "point_status";
        /**
         * 预警状态
         */
        public static final String POINT_COEFFICIENT = "point_coefficient";
        /**
         * 测斜仪孔个数
         */
        public static final String POINT_TUNNELS = "point_tunnels";
        /**
         * 外倾结构
         */
        public static final String POINT_TYPEDESC = "point_typedesc";
        /**
         * 高度
         */
        public static final String POINT_HEIGHT = "point_height";
    }

    /**
     * 城市区域表表
     */
    public static class CityTable {
        public static final String TABLE_NAME = "city_area_tb";
        /**
         * 街道id
         */
        public static final String STREET_ID = "street_id";
        /**
         * 城市
         */
        public static final String CITY = "city";
        /**
         * 区域
         */
        public static final String DISTRICT = "district";
        /**
         * 街道
         */
        public static final String STREET = "street";
        /**
         * 地址
         */
        public static final String FULL_NAME = "full_name";

    }


}
